CREATE EXTERNAL TABLE jms_dm.dm_tms_network_center_distri_dt
(
    code        string comment '网点编码',
    name        string comment '网点name',
    center_code string comment '中心编码',
    center_name string comment '中心name',
    size_num    string comment '对应交货中心数',
    waybill_num string comment '交货票数',
    date_time   string comment '日期'
)
    COMMENT '提供实时转运中心监控使用'
    PARTITIONED BY (
        dt string COMMENT 't-1')
    stored as parquet
    LOCATION '/dw/hive/jms_dm.db/external/dm_tms_network_center_distri_dt'